{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Welcome","Paver Selection","Area Description","Materials Selection","Customer Copy","Help","Listed Sheet","Cost Sheet"],"not_rendered":{"charts":0,"images":32,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Welcome","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Paver Selection","index":1,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,"Length (in)","Width (in)","Price","Price- sq/ft"]
[null,null,null,null,null,null,null,null,7.1,7.1,1.86,5.31]

{"sheet":"Area Description","index":2,"n_rows":24,"n_cols":4,"rows_kept":24,"cut":false,"hidden":false,"merged":[[23,2,23,3],[4,2,4,11],[8,2,8,3],[18,2,18,3]]}
[]
[]
[]
[]
[null,null,"Please Select a Purpose for your Project, then input the length and width of the area you would like to have paved."]
[]
[]
[]
[null,null,"Project Purpose"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Area (ft)"]
[null,null,"Length",10]
[null,null,"Width",30]
[null,null,"Sq/ FT",{"$f":"D20*D21","v":300}]
[]
[null,null,"General Notes:"]

{"sheet":"Materials Selection","index":3,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Price:",27.98]

{"sheet":"Customer Copy","index":4,"n_rows":30,"n_cols":4,"rows_kept":30,"cut":false,"hidden":false,"merged":[[10,3,10,6],[11,3,11,6],[7,3,7,6],[6,3,6,6],[8,3,8,6],[9,3,9,6]]}
[]
[]
[]
[]
[]
[]
[null,null,"Name",{"$f":"'Cost Sheet'!C12","v":"Jared"}]
[null,null,"Address",{"$f":"'Cost Sheet'!C13","v":58}]
[null,null,"Email",{"$f":"'Cost Sheet'!C14","v":"jared.court"}]
[null,null,"Paver Type",{"$f":"'Cost Sheet'!C16","v":"Belgard Providence Victorian paver"}]
[null,null,"Sealant",{"$f":"'Cost Sheet'!C17","v":"Concrete sealer (protect/waterproof)"}]
[null,null,"Project type",{"$f":"'Cost Sheet'!$C$15","v":"Driveway"}]
[null,null,"Square Footage",{"$f":"'Listed Sheet'!E26","v":300}]
[]
[null,null,"Estimate ",{"$f":"'Listed Sheet'!F41","v":3471.9494505058519}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"mitchclark@byu.net"]

{"sheet":"Help","index":5,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Mazanos- This spreadsheet was created to help people who are interested in putting pavers into their yard."]
[null,"As the first page says, you can input your information into the custom user form and then follow the pages "]
[null,"to put in the paver and the area along with the sealant that you would like. Then the Customer Copy will tell"]
[null,"you what the price is looking like for your project. "]
[null,"You can then press the submit form button and it will pull up instructions on how to submit your spreadsheet."]
[null,"Then an email will pop up below the button so that you can press it to bring up your email with Mitch's email "]
[null,"already put into the recipient bar."]
[]
[null,"Also, all of our computations are on hidden sheets. To unhide, you right click on the sheets bar at the bottom "]
[null,"of the workbook and click \"unhide\". That will let you bring up our computations. "]
[]
[null,"Note: Customers, Please DO NOT unhide the hidden sheets. We promise that all of our computations are fair "]
[null,"and reasonable. "]

{"sheet":"Listed Sheet","index":6,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":true,"merged":[[27,8,27,9],[22,3,22,4],[22,0,22,1]]}
["Paver Name","Length","Width","Price","Price- sq/ft"]
["Holland Red",7.7,3.8,0.51,{"$f":"144/(B2*C2)*D2","v":2.5099111414900888}]
["Holland Gray",7.7,3.8,0.51,{"$f":"144/(B3*C3)*D3","v":2.5099111414900888}]
["Countryside Tranquil Patio Stone",5.8,5.8,0.84,3.5957193816884661]
["Rectangle Gray Patio Stone",15.6,7.7,1.1399999999999999,1.3666333666333665]
["Belgard Providence Victorian paver",10.6,7.1,2.78,5.3191602444857828]
["Belgard Providence Victorian paver",7.1,7.1,1.86,5.3132315016861735]
["Rubberific Brown Paver",16,16,5.28,2.97]
["Charcoal Patio Stone",12,12,6.14,6.14]
["Square red Patio",11.7,11.7,1.69,1.7777777777777781]
["Square gray Patio",11.7,11.7,1.69,1.7777777777777781]
["Brickface Red Patio",15.7,15.7,4.1500000000000004,2.4244391253194864]
["Square Tan Patio Stone",11.7,11.7,1.69,1.7777777777777781]
[]
[]
["Item Name ","Price"]
["Concrete sealer (protect/waterproof)",27.98]
["Concrete sealer (wet look)",21.94]
["Paver Sealer (opt) gal ",39.979999999999997]
["Prefer not to apply",0]
[]
[]
["Pavers",null,null,"Plot dimensions"]
["Length",{"$f":"'Paver Selection'!I7","v":7.1},null,"Length",{"$f":"'Area Description'!D20","v":10}]
["Width ",{"$f":"'Paver Selection'!J7","v":7.1},null,"Width",{"$f":"'Area Description'!D21","v":30}]
["Cost",{"$f":"'Paver Selection'!K7","v":1.86},null,"Sq/Ft",{"$f":"'Area Description'!D22","v":300}]
["Cost sq/ft",{"$f":"'Paver Selection'!L7","v":5.31}]
[null,null,null,null,null,null,null,null,"Labor cost sq ft"]
[null,null,null,null,null,null,null,null,"Small/ rectangle",6]
[null,null,null,null,null,null,null,null,"Large/ square",5]
[]
["Paver Dimensions","Size","Size/ ft","Cost","size per sq/ft","Total Paver Cost"]
["Length",{"$f":"B24","v":7.1},{"$f":"B33/12","v":0.59166666666666667},{"$f":"B26","v":1.86},{"$f":"C33*C34","v":0.35006944444444443},{"$f":"B27*E26","v":1592.9999999999998}]
["Width",{"$f":"B25","v":7.1},{"$f":"B34/12","v":0.59166666666666667}]
[]
["Other Materials costs"]
["Material ","Unit","Unit Cost ","Units Needed",null,"Total"]
["Patio Sealer (opt) gal ",1,{"$f":"'Materials Selection'!D20","v":27.98},1,null,{"$f":"D38*C38","v":27.98}]
["Pavers",1,{"$f":"B26","v":1.86},{"$f":"E26/E33","v":856.9728228526086},null,{"$f":"C39*D39","v":1593.9694505058521}]
[]
[null,null,null,null,"Grand Total",{"$f":"SUM(F38:F39)+J29*E26+50","v":3471.9494505058519}]

{"sheet":"Cost Sheet","index":7,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"http://youtu.be/Lx8P47qOfo8?hd=1"]
[]
[]
[]
[null,"Customer Name","Jared"]
[null,"Customer Address",58]
[null,"Email Address","jared.court"]
[null,"Type of Project","Driveway"]
[null,"Paver","Belgard Providence Victorian paver"]
[null,"Sealer","Concrete sealer (protect/waterproof)"]